Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 18249 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 5.0 MiB |
| Average record size in memory | 288.8 B |
Variable types
| NUM | 10 |
|---|---|
| CAT | 4 |
Reproduction
| Analysis started | 2020-04-22 08:09:58.404988 |
|---|---|
| Analysis finished | 2020-04-22 08:11:30.477318 |
| Version | pandas-profiling v2.5.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
Date has a high cardinality: 169 distinct values | High cardinality |
region has a high cardinality: 54 distinct values | High cardinality |
4046 is highly correlated with Total Volume and 3 other fields | High Correlation |
Total Volume is highly correlated with 4046 and 3 other fields | High Correlation |
4225 is highly correlated with Total Volume and 3 other fields | High Correlation |
Total Bags is highly correlated with Total Volume and 4 other fields | High Correlation |
Small Bags is highly correlated with Total Volume and 4 other fields | High Correlation |
Large Bags is highly correlated with Total Bags and 1 other fields | High Correlation |
Date only contains datetime values, but is categorical. Consider applying pd.to_datetime() | Type |
Unnamed: 0 has 432 (2.4%) zeros | Zeros |
4046 has 242 (1.3%) zeros | Zeros |
4770 has 5497 (30.1%) zeros | Zeros |
Large Bags has 2370 (13.0%) zeros | Zeros |
XLarge Bags has 12048 (66.0%) zeros | Zeros |
| Distinct count | 53 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24.2322319 |
|---|---|
| Minimum | 0 |
| Maximum | 52 |
| Zeros | 432 |
| Zeros (%) | 2.4% |
| Memory size | 142.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 10 |
| median | 24 |
| Q3 | 38 |
| 95-th percentile | 49 |
| Maximum | 52 |
| Range | 52 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 15.48104475 |
|---|---|
| Coefficient of variation (CV) | 0.6388616953 |
| Kurtosis | -1.254364272 |
| Mean | 24.2322319 |
| Median Absolute Deviation (MAD) | 13.51943131 |
| Skewness | 0.1083337271 |
| Sum | 442214 |
| Variance | 239.6627467 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 0.5 11.5 51.5 52. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 7 | 432 | 2.4% | |
| 11 | 432 | 2.4% | |
| 1 | 432 | 2.4% | |
| 2 | 432 | 2.4% | |
| 3 | 432 | 2.4% | |
| 4 | 432 | 2.4% | |
| 5 | 432 | 2.4% | |
| 6 | 432 | 2.4% | |
| 8 | 432 | 2.4% | |
| 9 | 432 | 2.4% | |
| Other values (43) | 13929 | 76.3% |
| Value | Count | Frequency (%) | |
| 0 | 432 | 2.4% | |
| 1 | 432 | 2.4% | |
| 2 | 432 | 2.4% | |
| 3 | 432 | 2.4% | |
| 4 | 432 | 2.4% |
| Value | Count | Frequency (%) | |
| 52 | 107 | 0.6% | |
| 51 | 322 | 1.8% | |
| 50 | 324 | 1.8% | |
| 49 | 324 | 1.8% | |
| 48 | 324 | 1.8% |
| Distinct count | 169 |
|---|---|
| Unique (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 142.7 KiB |
| 2016-05-15 | 108 |
|---|---|
| 2016-10-23 | 108 |
| 2016-08-21 | 108 |
| 2015-03-08 | 108 |
| 2017-09-10 | 108 |
| Other values (164) |
| Value | Count | Frequency (%) | |
| 2016-05-15 | 108 | 0.6% | |
| 2016-10-23 | 108 | 0.6% | |
| 2016-08-21 | 108 | 0.6% | |
| 2015-03-08 | 108 | 0.6% | |
| 2017-09-10 | 108 | 0.6% | |
| 2015-03-15 | 108 | 0.6% | |
| 2015-10-04 | 108 | 0.6% | |
| 2015-10-18 | 108 | 0.6% | |
| 2018-02-25 | 108 | 0.6% | |
| 2017-10-15 | 108 | 0.6% | |
| Other values (159) | 17169 | 94.1% |
Length
| Max length | 10 |
|---|---|
| Mean length | 10 |
| Min length | 10 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 10 | 90.9% | |
| Dash_Punctuation | 1 | 9.1% |
| Value | Count | Frequency (%) | |
| Common | 11 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 11 | 100.0% |
AveragePrice
Real number (ℝ≥0)
| Distinct count | 259 |
|---|---|
| Unique (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.40597841 |
|---|---|
| Minimum | 0.44 |
| Maximum | 3.25 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 142.7 KiB |
Quantile statistics
| Minimum | 0.44 |
|---|---|
| 5-th percentile | 0.83 |
| Q1 | 1.1 |
| median | 1.37 |
| Q3 | 1.66 |
| 95-th percentile | 2.11 |
| Maximum | 3.25 |
| Range | 2.81 |
| Interquartile range (IQR) | 0.56 |
Descriptive statistics
| Standard deviation | 0.4026765555 |
|---|---|
| Coefficient of variation (CV) | 0.2864030861 |
| Kurtosis | 0.3251958507 |
| Mean | 1.40597841 |
| Median Absolute Deviation (MAD) | 0.3242800587 |
| Skewness | 0.5803027379 |
| Sum | 25657.7 |
| Variance | 0.1621484083 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.44 0.5 0.555 0.635 0.695 ... 2.195 2.405 2.675 2.945 3.25 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 1.15 | 202 | 1.1% | |
| 1.18 | 199 | 1.1% | |
| 1.08 | 194 | 1.1% | |
| 1.26 | 193 | 1.1% | |
| 1.13 | 192 | 1.1% | |
| 0.98 | 189 | 1.0% | |
| 1.19 | 188 | 1.0% | |
| 1.36 | 187 | 1.0% | |
| 1.59 | 186 | 1.0% | |
| 0.99 | 185 | 1.0% | |
| Other values (249) | 16334 | 89.5% |
| Value | Count | Frequency (%) | |
| 0.44 | 1 | < 0.1% | |
| 0.46 | 1 | < 0.1% | |
| 0.48 | 1 | < 0.1% | |
| 0.49 | 2 | < 0.1% | |
| 0.51 | 5 | < 0.1% |
| Value | Count | Frequency (%) | |
| 3.25 | 1 | < 0.1% | |
| 3.17 | 1 | < 0.1% | |
| 3.12 | 1 | < 0.1% | |
| 3.05 | 1 | < 0.1% | |
| 3.04 | 1 | < 0.1% |
| Distinct count | 18237 |
|---|---|
| Unique (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 850644.013 |
|---|---|
| Minimum | 84.56 |
| Maximum | 62505646.52 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 142.7 KiB |
Quantile statistics
| Minimum | 84.56 |
|---|---|
| 5-th percentile | 2371.862 |
| Q1 | 10838.58 |
| median | 107376.76 |
| Q3 | 432962.29 |
| 95-th percentile | 3716315.41 |
| Maximum | 62505646.52 |
| Range | 62505561.96 |
| Interquartile range (IQR) | 422123.71 |
Descriptive statistics
| Standard deviation | 3453545.355 |
|---|---|
| Coefficient of variation (CV) | 4.059918488 |
| Kurtosis | 92.10445778 |
| Mean | 850644.013 |
| Median Absolute Deviation (MAD) | 1182285.184 |
| Skewness | 9.007687479 |
| Sum | 1.552340259e+10 |
| Variance | 1.192697552e+13 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[8.45600000e+01 5.22985000e+02 9.90440000e+02 4.31942500e+03 9.22224500e+03 ... 2.25763489e+07 2.83569082e+07 3.84027183e+07 4.32888209e+07 6.25056465e+07], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 3713.49 | 2 | < 0.1% | |
| 3529.44 | 2 | < 0.1% | |
| 2038.99 | 2 | < 0.1% | |
| 569349.05 | 2 | < 0.1% | |
| 4103.97 | 2 | < 0.1% | |
| 9465.99 | 2 | < 0.1% | |
| 46602.16 | 2 | < 0.1% | |
| 2858.31 | 2 | < 0.1% | |
| 7223.46 | 2 | < 0.1% | |
| 19634.24 | 2 | < 0.1% | |
| Other values (18227) | 18229 | 99.9% |
| Value | Count | Frequency (%) | |
| 84.56 | 1 | < 0.1% | |
| 379.82 | 1 | < 0.1% | |
| 385.55 | 1 | < 0.1% | |
| 419.98 | 1 | < 0.1% | |
| 472.82 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 62505646.52 | 1 | < 0.1% | |
| 61034457.1 | 1 | < 0.1% | |
| 52288697.89 | 1 | < 0.1% | |
| 47293921.6 | 1 | < 0.1% | |
| 46324529.7 | 1 | < 0.1% |
| Distinct count | 17702 |
|---|---|
| Unique (%) | 97.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 293008.4245 |
|---|---|
| Minimum | 0 |
| Maximum | 22743616.17 |
| Zeros | 242 |
| Zeros (%) | 1.3% |
| Memory size | 142.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 19.6 |
| Q1 | 854.07 |
| median | 8645.3 |
| Q3 | 111020.2 |
| 95-th percentile | 1263359.678 |
| Maximum | 22743616.17 |
| Range | 22743616.17 |
| Interquartile range (IQR) | 110166.13 |
Descriptive statistics
| Standard deviation | 1264989.082 |
|---|---|
| Coefficient of variation (CV) | 4.317244747 |
| Kurtosis | 86.80911256 |
| Mean | 293008.4245 |
| Median Absolute Deviation (MAD) | 442392.3236 |
| Skewness | 8.648219757 |
| Sum | 5347110739 |
| Variance | 1.600197377e+12 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.00000000e+00 5.00000000e-01 1.20500000e+00 1.31500000e+00 2.35000000e+00 ... 3.35721745e+06 4.11477125e+06 8.28877151e+06 1.47464796e+07 2.27436162e+07], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 242 | 1.3% | |
| 3 | 10 | 0.1% | |
| 1.24 | 8 | < 0.1% | |
| 1 | 8 | < 0.1% | |
| 4 | 8 | < 0.1% | |
| 1.25 | 7 | < 0.1% | |
| 6 | 7 | < 0.1% | |
| 1.21 | 6 | < 0.1% | |
| 2.54 | 5 | < 0.1% | |
| 1.27 | 5 | < 0.1% | |
| Other values (17692) | 17943 | 98.3% |
| Value | Count | Frequency (%) | |
| 0 | 242 | 1.3% | |
| 1 | 8 | < 0.1% | |
| 1.13 | 1 | < 0.1% | |
| 1.19 | 3 | < 0.1% | |
| 1.2 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 22743616.17 | 1 | < 0.1% | |
| 21620180.9 | 1 | < 0.1% | |
| 18933038.04 | 1 | < 0.1% | |
| 17787611.93 | 1 | < 0.1% | |
| 17076650.82 | 1 | < 0.1% |
| Distinct count | 18103 |
|---|---|
| Unique (%) | 99.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 295154.5684 |
|---|---|
| Minimum | 0 |
| Maximum | 20470572.61 |
| Zeros | 61 |
| Zeros (%) | 0.3% |
| Memory size | 142.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 103.614 |
| Q1 | 3008.78 |
| median | 29061.02 |
| Q3 | 150206.86 |
| 95-th percentile | 1303657.658 |
| Maximum | 20470572.61 |
| Range | 20470572.61 |
| Interquartile range (IQR) | 147198.08 |
Descriptive statistics
| Standard deviation | 1204120.401 |
|---|---|
| Coefficient of variation (CV) | 4.079626508 |
| Kurtosis | 91.94902197 |
| Mean | 295154.5684 |
| Median Absolute Deviation (MAD) | 415666.6866 |
| Skewness | 8.942465608 |
| Sum | 5386275718 |
| Variance | 1.44990594e+12 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.00000000e+00 6.30000000e-01 6.90050000e+01 2.08185000e+02 2.70745000e+02 ... 2.96261700e+06 3.57276059e+06 9.52827016e+06 1.44096874e+07 2.04705726e+07], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 61 | 0.3% | |
| 215.36 | 3 | < 0.1% | |
| 177.87 | 3 | < 0.1% | |
| 1.3 | 3 | < 0.1% | |
| 94.74 | 3 | < 0.1% | |
| 1.26 | 3 | < 0.1% | |
| 3478.97 | 2 | < 0.1% | |
| 61.01 | 2 | < 0.1% | |
| 65.22 | 2 | < 0.1% | |
| 5.73 | 2 | < 0.1% | |
| Other values (18093) | 18165 | 99.5% |
| Value | Count | Frequency (%) | |
| 0 | 61 | 0.3% | |
| 1.26 | 3 | < 0.1% | |
| 1.28 | 2 | < 0.1% | |
| 1.3 | 3 | < 0.1% | |
| 1.31 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 20470572.61 | 1 | < 0.1% | |
| 20445501.03 | 1 | < 0.1% | |
| 20328161.55 | 1 | < 0.1% | |
| 18956479.74 | 1 | < 0.1% | |
| 17896391.6 | 1 | < 0.1% |
| Distinct count | 12071 |
|---|---|
| Unique (%) | 66.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22839.73599 |
|---|---|
| Minimum | 0 |
| Maximum | 2546439.11 |
| Zeros | 5497 |
| Zeros (%) | 30.1% |
| Memory size | 142.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 184.99 |
| Q3 | 6243.42 |
| 95-th percentile | 106156.574 |
| Maximum | 2546439.11 |
| Range | 2546439.11 |
| Interquartile range (IQR) | 6243.42 |
Descriptive statistics
| Standard deviation | 107464.0684 |
|---|---|
| Coefficient of variation (CV) | 4.705136192 |
| Kurtosis | 132.5634409 |
| Mean | 22839.73599 |
| Median Absolute Deviation (MAD) | 35858.8782 |
| Skewness | 10.15939563 |
| Sum | 416802342.1 |
| Variance | 1.1548526e+10 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.00000000e+00 4.15000000e-01 1.10000000e+00 1.55500000e+00 1.66500000e+00 ... 4.29274150e+05 6.70690805e+05 1.14980665e+06 1.88819044e+06 2.54643911e+06], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 5497 | 30.1% | |
| 2.66 | 7 | < 0.1% | |
| 3.32 | 7 | < 0.1% | |
| 1.64 | 6 | < 0.1% | |
| 10.97 | 6 | < 0.1% | |
| 1.6 | 6 | < 0.1% | |
| 1.59 | 6 | < 0.1% | |
| 2.74 | 5 | < 0.1% | |
| 1.65 | 5 | < 0.1% | |
| 1.63 | 5 | < 0.1% | |
| Other values (12061) | 12699 | 69.6% |
| Value | Count | Frequency (%) | |
| 0 | 5497 | 30.1% | |
| 0.83 | 1 | < 0.1% | |
| 1 | 3 | < 0.1% | |
| 1.01 | 1 | < 0.1% | |
| 1.09 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2546439.11 | 1 | < 0.1% | |
| 1993645.36 | 1 | < 0.1% | |
| 1896149.5 | 1 | < 0.1% | |
| 1880231.38 | 1 | < 0.1% | |
| 1811090.71 | 1 | < 0.1% |
| Distinct count | 18097 |
|---|---|
| Unique (%) | 99.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 239639.2021 |
|---|---|
| Minimum | 0 |
| Maximum | 19373134.37 |
| Zeros | 15 |
| Zeros (%) | 0.1% |
| Memory size | 142.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 628.89 |
| Q1 | 5088.64 |
| median | 39743.83 |
| Q3 | 110783.37 |
| 95-th percentile | 1005478.892 |
| Maximum | 19373134.37 |
| Range | 19373134.37 |
| Interquartile range (IQR) | 105694.73 |
Descriptive statistics
| Standard deviation | 986242.3992 |
|---|---|
| Coefficient of variation (CV) | 4.115530309 |
| Kurtosis | 112.2721565 |
| Mean | 239639.2021 |
| Median Absolute Deviation (MAD) | 331874.7799 |
| Skewness | 9.75607167 |
| Sum | 4373175798 |
| Variance | 9.7267407e+11 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.00000000e+00 1.54500000e+00 1.35380000e+02 9.23525000e+02 1.82781500e+03 ... 1.67650435e+06 2.42276084e+06 3.33119568e+06 1.34974075e+07 1.93731344e+07], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 15 | 0.1% | |
| 300 | 5 | < 0.1% | |
| 990 | 5 | < 0.1% | |
| 916.67 | 4 | < 0.1% | |
| 266.67 | 4 | < 0.1% | |
| 550 | 4 | < 0.1% | |
| 856.67 | 3 | < 0.1% | |
| 153.33 | 3 | < 0.1% | |
| 196.67 | 3 | < 0.1% | |
| 803.33 | 3 | < 0.1% | |
| Other values (18087) | 18200 | 99.7% |
| Value | Count | Frequency (%) | |
| 0 | 15 | 0.1% | |
| 3.09 | 1 | < 0.1% | |
| 3.11 | 1 | < 0.1% | |
| 3.19 | 1 | < 0.1% | |
| 3.33 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 19373134.37 | 1 | < 0.1% | |
| 16394524.11 | 1 | < 0.1% | |
| 16298296.29 | 1 | < 0.1% | |
| 15972492.07 | 1 | < 0.1% | |
| 15804696.31 | 1 | < 0.1% |
| Distinct count | 17321 |
|---|---|
| Unique (%) | 94.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 182194.6867 |
|---|---|
| Minimum | 0 |
| Maximum | 13384586.8 |
| Zeros | 159 |
| Zeros (%) | 0.9% |
| Memory size | 142.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 256.67 |
| Q1 | 2849.42 |
| median | 26362.82 |
| Q3 | 83337.67 |
| 95-th percentile | 768147.228 |
| Maximum | 13384586.8 |
| Range | 13384586.8 |
| Interquartile range (IQR) | 80488.25 |
Descriptive statistics
| Standard deviation | 746178.515 |
|---|---|
| Coefficient of variation (CV) | 4.095500964 |
| Kurtosis | 107.0128851 |
| Mean | 182194.6867 |
| Median Absolute Deviation (MAD) | 255386.2209 |
| Skewness | 9.540659982 |
| Sum | 3324870838 |
| Variance | 5.567823762e+11 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.00000000e+00 1.26000000e+00 4.33150000e+01 4.33700000e+01 1.23280000e+02 ... 1.46320821e+06 1.99085395e+06 2.34447192e+06 1.00721255e+07 1.33845868e+07], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 159 | 0.9% | |
| 203.33 | 11 | 0.1% | |
| 533.33 | 10 | 0.1% | |
| 223.33 | 10 | 0.1% | |
| 103.33 | 8 | < 0.1% | |
| 326.67 | 8 | < 0.1% | |
| 300 | 8 | < 0.1% | |
| 196.67 | 8 | < 0.1% | |
| 263.33 | 8 | < 0.1% | |
| 123.33 | 8 | < 0.1% | |
| Other values (17311) | 18011 | 98.7% |
| Value | Count | Frequency (%) | |
| 0 | 159 | 0.9% | |
| 2.52 | 1 | < 0.1% | |
| 2.57 | 1 | < 0.1% | |
| 2.73 | 1 | < 0.1% | |
| 2.79 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 13384586.8 | 1 | < 0.1% | |
| 12567155.58 | 1 | < 0.1% | |
| 12540327.19 | 1 | < 0.1% | |
| 11712807.19 | 1 | < 0.1% | |
| 11392828.89 | 1 | < 0.1% |
| Distinct count | 15082 |
|---|---|
| Unique (%) | 82.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54338.08814 |
|---|---|
| Minimum | 0 |
| Maximum | 5719096.61 |
| Zeros | 2370 |
| Zeros (%) | 13.0% |
| Memory size | 142.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 127.47 |
| median | 2647.71 |
| Q3 | 22029.25 |
| 95-th percentile | 195699.768 |
| Maximum | 5719096.61 |
| Range | 5719096.61 |
| Interquartile range (IQR) | 21901.78 |
Descriptive statistics
| Standard deviation | 243965.9645 |
|---|---|
| Coefficient of variation (CV) | 4.489778218 |
| Kurtosis | 117.999481 |
| Mean | 54338.08814 |
| Median Absolute Deviation (MAD) | 80189.47525 |
| Skewness | 9.796454599 |
| Sum | 991615770.6 |
| Variance | 5.951939186e+10 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.00000000e+00 4.85000000e-01 1.31500000e+00 2.63500000e+00 2.80500000e+00 ... 4.28980800e+05 6.18057115e+05 1.25633789e+06 3.40688538e+06 5.71909661e+06], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 2370 | 13.0% | |
| 3.33 | 187 | 1.0% | |
| 6.67 | 78 | 0.4% | |
| 10 | 47 | 0.3% | |
| 4.44 | 38 | 0.2% | |
| 13.33 | 28 | 0.2% | |
| 16.67 | 18 | 0.1% | |
| 6.66 | 18 | 0.1% | |
| 26.67 | 18 | 0.1% | |
| 20 | 14 | 0.1% | |
| Other values (15072) | 15433 | 84.6% |
| Value | Count | Frequency (%) | |
| 0 | 2370 | 13.0% | |
| 0.97 | 1 | < 0.1% | |
| 1.3 | 1 | < 0.1% | |
| 1.33 | 1 | < 0.1% | |
| 1.38 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5719096.61 | 1 | < 0.1% | |
| 4324231.19 | 1 | < 0.1% | |
| 4081397.72 | 1 | < 0.1% | |
| 4023485.04 | 1 | < 0.1% | |
| 3988101.74 | 1 | < 0.1% |
| Distinct count | 5588 |
|---|---|
| Unique (%) | 30.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3106.426507 |
|---|---|
| Minimum | 0 |
| Maximum | 551693.65 |
| Zeros | 12048 |
| Zeros (%) | 66.0% |
| Memory size | 142.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 132.5 |
| 95-th percentile | 12058.452 |
| Maximum | 551693.65 |
| Range | 551693.65 |
| Interquartile range (IQR) | 132.5 |
Descriptive statistics
| Standard deviation | 17692.89465 |
|---|---|
| Coefficient of variation (CV) | 5.695578058 |
| Kurtosis | 233.6026119 |
| Mean | 3106.426507 |
| Median Absolute Deviation (MAD) | 5207.813525 |
| Skewness | 13.13975069 |
| Sum | 56689177.33 |
| Variance | 313038521.2 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.00000000e+00 5.00000000e-01 1.05500000e+00 3.32500000e+00 3.34000000e+00 ... 3.85374550e+04 7.21911850e+04 1.08385985e+05 3.27468620e+05 5.51693650e+05], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 12048 | 66.0% | |
| 3.33 | 29 | 0.2% | |
| 6.67 | 16 | 0.1% | |
| 1.11 | 15 | 0.1% | |
| 5 | 12 | 0.1% | |
| 10 | 9 | < 0.1% | |
| 16.67 | 8 | < 0.1% | |
| 2.22 | 7 | < 0.1% | |
| 150 | 6 | < 0.1% | |
| 80 | 6 | < 0.1% | |
| Other values (5578) | 6093 | 33.4% |
| Value | Count | Frequency (%) | |
| 0 | 12048 | 66.0% | |
| 1 | 1 | < 0.1% | |
| 1.11 | 15 | 0.1% | |
| 1.26 | 1 | < 0.1% | |
| 1.3 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 551693.65 | 1 | < 0.1% | |
| 454343.65 | 1 | < 0.1% | |
| 390478.73 | 1 | < 0.1% | |
| 387400.22 | 1 | < 0.1% | |
| 377661.06 | 1 | < 0.1% |
type
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 142.7 KiB |
| conventional | |
|---|---|
| organic |
| Value | Count | Frequency (%) | |
| conventional | 9126 | 50.0% | |
| organic | 9123 | 50.0% |
Length
| Max length | 12 |
|---|---|
| Mean length | 9.500410981 |
| Min length | 7 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 11 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 11 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 11 | 100.0% |
year
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 142.7 KiB |
| 2017 | |
|---|---|
| 2016 | |
| 2015 | |
| 2018 |
| Value | Count | Frequency (%) | |
| 2017 | 5722 | 31.4% | |
| 2016 | 5616 | 30.8% | |
| 2015 | 5615 | 30.8% | |
| 2018 | 1296 | 7.1% |
Length
| Max length | 4 |
|---|---|
| Mean length | 4 |
| Min length | 4 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 7 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 7 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 7 | 100.0% |
| Distinct count | 54 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 142.7 KiB |
| Seattle | 338 |
|---|---|
| PhoenixTucson | 338 |
| Southeast | 338 |
| LasVegas | 338 |
| Louisville | 338 |
| Other values (49) |
| Value | Count | Frequency (%) | |
| Seattle | 338 | 1.9% | |
| PhoenixTucson | 338 | 1.9% | |
| Southeast | 338 | 1.9% | |
| LasVegas | 338 | 1.9% | |
| Louisville | 338 | 1.9% | |
| Houston | 338 | 1.9% | |
| Northeast | 338 | 1.9% | |
| Detroit | 338 | 1.9% | |
| MiamiFtLauderdale | 338 | 1.9% | |
| Plains | 338 | 1.9% | |
| Other values (44) | 14869 | 81.5% |
Length
| Max length | 19 |
|---|---|
| Mean length | 10.29535865 |
| Min length | 4 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 23 | 51.1% | |
| Uppercase_Letter | 22 | 48.9% |
| Value | Count | Frequency (%) | |
| Latin | 45 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 45 | 100.0% |
First rows
| Unnamed: 0 | Date | AveragePrice | Total Volume | 4046 | 4225 | 4770 | Total Bags | Small Bags | Large Bags | XLarge Bags | type | year | region | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 2015-12-27 | 1.33 | 64236.62 | 1036.74 | 54454.85 | 48.16 | 8696.87 | 8603.62 | 93.25 | 0.0 | conventional | 2015 | Albany |
| 1 | 1 | 2015-12-20 | 1.35 | 54876.98 | 674.28 | 44638.81 | 58.33 | 9505.56 | 9408.07 | 97.49 | 0.0 | conventional | 2015 | Albany |
| 2 | 2 | 2015-12-13 | 0.93 | 118220.22 | 794.70 | 109149.67 | 130.50 | 8145.35 | 8042.21 | 103.14 | 0.0 | conventional | 2015 | Albany |
| 3 | 3 | 2015-12-06 | 1.08 | 78992.15 | 1132.00 | 71976.41 | 72.58 | 5811.16 | 5677.40 | 133.76 | 0.0 | conventional | 2015 | Albany |
| 4 | 4 | 2015-11-29 | 1.28 | 51039.60 | 941.48 | 43838.39 | 75.78 | 6183.95 | 5986.26 | 197.69 | 0.0 | conventional | 2015 | Albany |
| 5 | 5 | 2015-11-22 | 1.26 | 55979.78 | 1184.27 | 48067.99 | 43.61 | 6683.91 | 6556.47 | 127.44 | 0.0 | conventional | 2015 | Albany |
| 6 | 6 | 2015-11-15 | 0.99 | 83453.76 | 1368.92 | 73672.72 | 93.26 | 8318.86 | 8196.81 | 122.05 | 0.0 | conventional | 2015 | Albany |
| 7 | 7 | 2015-11-08 | 0.98 | 109428.33 | 703.75 | 101815.36 | 80.00 | 6829.22 | 6266.85 | 562.37 | 0.0 | conventional | 2015 | Albany |
| 8 | 8 | 2015-11-01 | 1.02 | 99811.42 | 1022.15 | 87315.57 | 85.34 | 11388.36 | 11104.53 | 283.83 | 0.0 | conventional | 2015 | Albany |
| 9 | 9 | 2015-10-25 | 1.07 | 74338.76 | 842.40 | 64757.44 | 113.00 | 8625.92 | 8061.47 | 564.45 | 0.0 | conventional | 2015 | Albany |
Last rows
| Unnamed: 0 | Date | AveragePrice | Total Volume | 4046 | 4225 | 4770 | Total Bags | Small Bags | Large Bags | XLarge Bags | type | year | region | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18239 | 2 | 2018-03-11 | 1.56 | 22128.42 | 2162.67 | 3194.25 | 8.93 | 16762.57 | 16510.32 | 252.25 | 0.0 | organic | 2018 | WestTexNewMexico |
| 18240 | 3 | 2018-03-04 | 1.54 | 17393.30 | 1832.24 | 1905.57 | 0.00 | 13655.49 | 13401.93 | 253.56 | 0.0 | organic | 2018 | WestTexNewMexico |
| 18241 | 4 | 2018-02-25 | 1.57 | 18421.24 | 1974.26 | 2482.65 | 0.00 | 13964.33 | 13698.27 | 266.06 | 0.0 | organic | 2018 | WestTexNewMexico |
| 18242 | 5 | 2018-02-18 | 1.56 | 17597.12 | 1892.05 | 1928.36 | 0.00 | 13776.71 | 13553.53 | 223.18 | 0.0 | organic | 2018 | WestTexNewMexico |
| 18243 | 6 | 2018-02-11 | 1.57 | 15986.17 | 1924.28 | 1368.32 | 0.00 | 12693.57 | 12437.35 | 256.22 | 0.0 | organic | 2018 | WestTexNewMexico |
| 18244 | 7 | 2018-02-04 | 1.63 | 17074.83 | 2046.96 | 1529.20 | 0.00 | 13498.67 | 13066.82 | 431.85 | 0.0 | organic | 2018 | WestTexNewMexico |
| 18245 | 8 | 2018-01-28 | 1.71 | 13888.04 | 1191.70 | 3431.50 | 0.00 | 9264.84 | 8940.04 | 324.80 | 0.0 | organic | 2018 | WestTexNewMexico |
| 18246 | 9 | 2018-01-21 | 1.87 | 13766.76 | 1191.92 | 2452.79 | 727.94 | 9394.11 | 9351.80 | 42.31 | 0.0 | organic | 2018 | WestTexNewMexico |
| 18247 | 10 | 2018-01-14 | 1.93 | 16205.22 | 1527.63 | 2981.04 | 727.01 | 10969.54 | 10919.54 | 50.00 | 0.0 | organic | 2018 | WestTexNewMexico |
| 18248 | 11 | 2018-01-07 | 1.62 | 17489.58 | 2894.77 | 2356.13 | 224.53 | 12014.15 | 11988.14 | 26.01 | 0.0 | organic | 2018 | WestTexNewMexico |